Re: [GENERAL] btree index on a char(8) field (fwd) - Mailing list pgsql-general

From Herouth Maoz
Subject Re: [GENERAL] btree index on a char(8) field (fwd)
Date
Msg-id l03130301b421030e5355@[147.233.159.109]
Whole thread Raw
In response to btree index on a char(8) field (fwd)  (Frank Mandarino <fam@risca.com>)
Responses Re: [GENERAL] btree index on a char(8) field (fwd)
List pgsql-general
At 15:30 +0200 on 06/10/1999, Frank Mandarino wrote:


> main=> create index ven_code_idx on vendor using btree (ven_code char_ops);
> CREATE

I didn't have time to check this, but the problem may be caused by the
incorrect ops you are using. For char(N) it should be bpchar_ops, not
char_ops.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma



pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Foreign Key
Next
From: Jelle Ruttenberg
Date:
Subject: Q: ODBC- and PostgreSQL-datatypes difference?